Knowledge Drop

Send Look to SFTP Server Via Python SDK

  • 7 July 2021
  • 0 replies
  • 13 views

Userlevel 4
Badge

Last tested: Jun 18, 2020
 

If someone wants to send content to an SFTP server, but does not want to want to use the UI, they can use the API.

import looker_sdk

import csv

import pysftp

#SET SFTP CREDENTIALS HERE. IT IS RECOMMENDED TO SET THEM IN ANOTHER FILE AND IMPORT THEM SECURELY

myHostname = "DOMAIN"

myUsername = "user"

myPassword = "PASSWORD"

 

####Initialize API/SDK for more info go here: https://pypi.org/project/looker-sdk/

#### IN THE SAME DIRECTORY CREATE AN INI FILE TO STORE API CREDENTIALS

## INITIALIZE THE API

from looker_sdk import methods31, models

sdk = looker_sdk.init31() # or init40() for v4.0 API

me = sdk.me()

### GET THE LOOK BY PASSING THE LOOK ID

### WE ALSO WRITE THE FILE TO THE LOCAL DIRECTORY AS A CSV

look = sdk.run_look(look_id=12, result_format = "csv")

file = open('read.csv', 'w')

file.write(look)

file.close()

### HERE WE SEND THE CSV TO THE SFTP SERVER

with pysftp.Connection(host=myHostname, username=myUsername, password=myPassword) as sftp:

print("Connection succesfully stablished ... ")

localFilePath = 'read.csv'

 

# Define the remote path where the file will be uploaded

remoteFilePath = '/files/NEWFILE/read.csv'

sftp.put(localFilePath, remoteFilePath)

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply