Data warehouses¶

Import and export data into/from data warehouses (DWH).

Data warehouses are powerful but expensive. I/O adapters listed here support you to offload data into CrateDB, for cost-effective data analytics.

Integrations¶

Amazon Redshift

Databricks

Google BigQuery

MotherDuck

SAP HANA

Snowflake

Teradata

Synopsis¶

Load data from BigQuery table into CrateDB table.

ctk load \
    "bigquery://<project-name>?credentials_path=/path/to/service/account.json&location=<location>&table=<table-name>" \
    "crate://crate:na@localhost:4200/testdrive/bigquery"

Load data from Databricks table into CrateDB table.

ctk load \
    "databricks://token:<access_token>@<server_hostname>?http_path=<http_path>&catalog=<catalog>&schema=<schema>&table=demo" \
    "crate://crate:na@localhost:4200/testdrive/databricks"

Load data from SAP HANA table into CrateDB table.

ctk load \
    "hana://SYSTEM:HXEHana1@localhost:39017/SYSTEMDB?table=sys.adapters" \
    "crate://crate:na@localhost:4200/testdrive/hana"

Load data from MotherDuck table into CrateDB table.

ctk load \
    "motherduck://<database-name>?token=<your-token>&table=<schema-name>.<table-name>" \
    "crate://crate:na@localhost:4200/testdrive/motherduck"

Load data from Redshift table into CrateDB table.

ctk load \
    "redshift+psycopg2://<username>:<password>@host.amazonaws.com:5439/database?table=demo" \
    "crate://crate:na@localhost:4200/testdrive/redshift"

Load data from Snowflake table into CrateDB table.

ctk load \
    "snowflake://<username>:<password>@account/dbname?warehouse=COMPUTE_WH&role=data_scientist&table=demo" \
    "crate://crate:na@localhost:4200/testdrive/snowflake"

Load data from Teradata table into CrateDB table.

ctk load \
    "teradatasql://guest:please@teradata.example.com/?table=demo" \
    "crate://crate:na@localhost:4200/testdrive/teradata"