Cloud Warehouses & Databases

Snowflake

Parameter	Type	Required	Default	Description
account	string	✅	—	Snowflake account identifier
user	string	✅	—	Username
password	string	✅	—	Password
warehouse	string	✅	—	Warehouse name
database	string	✅	—	Database name
schema	string	✅	—	Schema name
query	string	✅	—	SQL query
role	string	❌	—	Role to assume
timeout	integer	❌	30	Login timeout (seconds)

Google BigQuery

Parameter	Type	Required	Default	Description
gcp_credentials_json	string	✅	—	GCP service account JSON
project_id	string	✅	—	GCP project ID
query	string	✅	—	SQL query
dataset_id	string	❌	—	Default dataset ID
timeout	integer	❌	60	Query timeout (seconds)

Databricks

Parameter	Type	Required	Default	Description
host	string	✅	—	Databricks workspace URL
http_path	string	✅	—	SQL warehouse HTTP path
token	string	✅	—	Personal access token
query	string	✅	—	SQL query
catalog	string	❌	hive_metastore	Catalog name
schema	string	❌	default	Schema name

Microsoft SQL Server

Parameter	Type	Required	Default	Description
host	string	✅	—	SQL Server hostname
port	integer	✅	1433	Port
user	string	✅	—	Username
password	string	✅	—	Password
database	string	✅	—	Database name
query	string	✅	—	SQL query
driver	string	❌	—	ODBC driver name (informational)
timeout	integer	❌	30	Timeout (seconds)

Oracle Database

Parameter	Type	Required	Default	Description
host	string	✅	—	Oracle hostname
port	integer	✅	1521	Listener port
user	string	✅	—	Username
password	string	✅	—	Password
service_name	string	✅	—	Service name or SID
query	string	✅	—	SQL query
timeout	integer	❌	30	Connection timeout (seconds)