BigQuery retrieve data from sftp

I have an internet facing sftp server that has regularly csv files update. Is there anyway command to have BigQuery to retrieve data from this sftp and put it into tables. Alternatively, any API or python library that support this?

As for BigQuery - there's no integration I know of with SFTP.

You'll need to either:

• Create/find a script that reads from SFTP and pushes to GCS.
• Add a HTTPS service to the SFTP server, so your data can be read with the GCS transfer service (https://cloud.google.com/storage-transfer/docs/)