Specifies the file storage service, server, or file access protocol through which your CSV files are stored and retreived.

Possible Values

Auto, Local, Amazon S3, Azure Blob Storage, Azure Data Lake Storage Gen1, Azure Data Lake Storage Gen2, Azure Data Lake Storage Gen2 SSL, Azure Files, Box, Dropbox, FTP, FTPS, Google Cloud Storage, Google Drive, HDFS, HDFS Secure, HTTP, HTTPS, IBM Object Storage Source, OneDrive, Oracle Cloud Storage, SFTP, SharePoint REST, SharePoint SOAP

Data Type

string

Default Value

"Auto"

Remarks

Set the ConnectionType to one of the following:

• Auto: The driver infers the connection type from the syntax of the provided URI.
• Local: CSV files stored on your local machine.
• Amazon S3
• Azure Blob Storage
• Azure Data Lake Storage Gen1
• Azure Data Lake Storage Gen2
• Azure Data Lake Storage Gen2 SSL
• Azure Files
• Box
• Dropbox
• FTP
• FTPS
• Google Cloud Storage
• Google Drive
• HDFS
• HDFS Secure
• HTTP: Connects to CSV files hosted on HTTP streams.
• HTTPS: Connects to CSV files hosted on HTTPS streams.
• IBM Object Storage Source
• OneDrive
• Oracle Cloud Storage
• SFTP
• SharePoint REST
• SharePoint SOAP

Set the ConnectionType to one of the following:

• Auto: The driver infers the connection type from the syntax of the provided URI.
• Local: CSV files stored on your local machine.
• Amazon S3
• Azure Blob Storage
• Azure Data Lake Storage Gen1
• Azure Data Lake Storage Gen2
• Azure Data Lake Storage Gen2 SSL
• Azure Files
• Box
• Dropbox
• FTP
• FTPS
• Google Cloud Storage
• Google Drive
• HDFS
• HDFS Secure
• HTTP: Connects to CSV files hosted on HTTP streams.
• HTTPS: Connects to CSV files hosted on HTTPS streams.
• IBM Object Storage Source
• OneDrive
• Oracle Cloud Storage
• SFTP
• SharePoint REST
• SharePoint SOAP