aws_access_key_id
: The AWS access key that identifies the user or IAM role.aws_secret_access_key
: The AWS secret access key that identifies the user or IAM role.region_name
: The AWS region to connect to.aws_session_token
: The AWS session token that identifies the user or IAM role. This becomes necessary when using temporary security credentials.host
: The host name or IP address of the Redshift cluster.port
: The port to use when connecting with the Redshift cluster.database
: The database name to use when connecting with the Redshift cluster.user
: The username to authenticate the user with the Redshift cluster.password
: The password to authenticate the user with the Redshift cluster.schema
: The database schema to use. Defaults to public
.sslmode
: The SSL mode for the connection.tables
refer to the files available in the connected bucket(s). This can be a list of file names or file paths. For example, tables=['file1.csv', 'folder/file2.csv']
.
Additionally, a special table called files
is available that lists all the files along with their content in the connected bucket(s).
Note that sample parameter values are provided here for reference, and you should replace them with your connection parameters.
Required connection parameters include the following:
aws_access_key_id
: The AWS access key that identifies the user or IAM role.aws_secret_access_key
: The AWS secret access key that identifies the user or IAM role.aws_session_token
: The AWS session token that identifies the user or IAM role. This becomes necessary when using temporary security credentials.bucket
: The name of the Amazon S3 bucket. If not provided, all available buckets can be queried, however, this can affect performance, especially when listing all of the available objects.host
: The hostname or IP address of the ClickHouse server.port
: The TCP/IP port of the ClickHouse server.user
: The username used to authenticate with the ClickHouse server.password
: The password to authenticate the user with the ClickHouse server.database
: The database name to use when connecting with the ClickHouse server. Defaults to default
.protocol
: It is an optional parameter. Its supported values are native
, http
and https
. Defaults to native
.server_hostname
: The server hostname for the cluster or SQL warehouse.http_path
: The HTTP path of the cluster or SQL warehouse.access_token
: A Databricks personal access token for the workspace.session_configuration
: Additional (key, value) pairs to set as Spark session configuration parameters. This should be provided as a JSON string.http_headers
: Additional (key, value) pairs to set in HTTP headers on every RPC request the client makes. This should be provided as a JSON string.catalog
: The catalog to use for the connection.schema
: The schema (database) to use for the connection.cloud_id
: The Cloud ID provided with the ElasticSearch deployment. Required only when hosts
is not provided.hosts
: The ElasticSearch endpoint provided with the ElasticSearch deployment. Required only when cloud_id
is not provided.api_key
: The API key that you generated for the ElasticSearch deployment. Required only when user
and password
are not provided.user
and password
: The user and password used to authenticate. Required only when api_key
is not provided.project_id
: The globally unique identifier for your project in Google Cloud where BigQuery is located.dataset
: The default dataset to connect to.service_account_json
: It stores the content of the service account keys file used to autheticate the user.user
: The username for the MariaDB database.password
: The password for the MariaDB database.host
: The hostname, IP address, or URL of the MariaDB server.port
: The port number for connecting to the MariaDB server.database
: The name of the MariaDB database to connect to.url
parameter to specify a connection to MariaDB Server using a URI-like string. You can also use mysql://
as the protocol prefix.
Accounts in this organizational directory only
option for the Supported account types field.Files.Read
permission and select it.client_id
parameter, and copy the Directory (tenant) ID and record it as the tenant_id
parameter.client_secret
parameter.https://mdb.ai/verify-auth
in the Redirect URIs field.tables
refer to the files available in the connected account. This can be a list of file names or file paths. For example, tables=['file1.csv', 'folder/file2.csv']
.
Additionally, a special table called files
is available that lists all the files along with their content in the connected account.
Note that sample parameter values are provided here for reference, and you should replace them with your connection parameters.
Required connection parameters include the following:
client_id
: The client ID of the registered application.client_secret
: The client secret of the registered application.tenant_id
: The tenant ID of the registered application.user
: The username for the Microsoft SQL Server.password
: The password for the Microsoft SQL Server.host
The hostname, IP address, or URL of the Microsoft SQL Server.database
The name of the Microsoft SQL Server database to connect to.port
: The port number for connecting to the Microsoft SQL Server. Defaults to 1433
.server
: The server name to connect to. Typically only used with named instances or Azure SQL Database.host
: The connection string of the MongoDB server that includes user (user
), password (password
), host and port (demo-data-mdb.trzfwvb.mongodb.net
).database
: The name of the database.username
: The username associated with the database.password
: The password to authenticate your access.host
: The host of the MongoDB server.port
: The port through which TCP/IP connection is to be made.database
: The database name to be connected.user
: The username for the MySQL database.password
: The password for the MySQL database.host
: The hostname, IP address, or URL of the MySQL server.port
: The port number for connecting to the MySQL server.database
: The name of the MySQL database to connect to.url
parameter to specify a connection to MySQL Server using a URI-like string.
user
: The username for the PostgreSQL database.password
: The password for the PostgreSQL database.host
: The hostname, IP address, or URL of the PostgreSQL server.port
: The port number for connecting to the PostgreSQL server.database
: The name of the PostgreSQL database to connect to.schema
: The database schema to use. Defaults to public
.sslmode
: The SSL mode for the connection.account
: The Snowflake account identifier. This guide will help you find your account identifier.user
: The username for the Snowflake account.password
: The password for the Snowflake account.database
: The name of the Snowflake database to connect to.warehouse
: The Snowflake warehouse to use for running queries.schema
: The database schema to use within the Snowflake database. Defaults to PUBLIC
.role
: The Snowflake role to use.host
: The hostname, IP address, or URL of the Teradata server.user
: The username for the Teradata database.password
: The password for the Teradata database.database
: The name of the Teradata database to connect to. Defaults to the user’s default database.