Data Source configurations are set in the Data / Data Sources panel of the Domino UI. You can update it there for any permanent change.
Some configuration attributes can be overridden locally in the API. A sample of Data Source type configuration is described in the Classes section below.
You can create a configuration override with any of the config classes and update your Data Source entity:
from domino.data_sources import DataSourceClient, SnowflakeConfig
snowflake = DataSourceClient().get_datasource("snowflake-prod")
# Build a override config with a different warehouse than configured in Domino
config_xxl = SnowflakeConfig(warehouse="compute-xxl")
# Local update with no permanent change
snowflake.update(config=config_xxl)
res = snowflake.query("SELECT COUNT(*) FROM very_large_table")
# Override can also be used for temporary credentials
snowflake.update(config=SnowflakeConfig(username="admin", password="<password>"))
res = snowflake.query("SELECT secret_data FROM secret_table LIMIT 10")To remove the configuration override, simply reset it:
from domino.data_sources import DataSourceClient, SnowflakeConfig
snowflake = DataSourceClient().get_datasource("snowflake-prod")
# Update to dev database
snowflake.update(SnowflakeConfig(database="dev"))
# Reset to default values
snowflake.reset_config()
res = snowflake.query("SELECT * FROM prod_table")Relational Data Sources support an optional datetime precision field, which is overridable in the Data API for version 6.3.0 and above. Adjusting the precision prevents extreme datetimes from overflowing. The precision can be set to "seconds", "milliseconds", "microseconds", or "nanoseconds", with "nanoseconds" as the default.
from domino.data_sources import DataSourceClient, SnowflakeConfig
snowflake = DataSourceClient().get_datasource("snowflake-prod")
# Update to datetime precision to milliseconds to support extremely large datetime values
snowflake.update(SnowflakeConfig(datetime_precision="milliseconds"))
res = snowflake.query("SELECT * FROM prod_table")Below are examples of Data Sources and their configurable override options for v6.7.4 of the Domino Data API.
The source code for these class definitions is available on GitHub.
Work with Data Source Connectors has instructions on how to set up the Data Sources.
Databricks
class domino_data.data_sources.DatabricksConfig(
*, datetime_precision=None, catalog=None, schema=None,
personal_access_token=None
)Databricks datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
DB2Native
class domino_data.data_sources.DB2NativeConfig(
*, database=None, datetime_precision=None, username=None,
password=None, dsn=None
)DB2Native datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
GenericS3
class domino_data.data_sources.GenericS3Config(
*, bucket=None, subfolder=None, host=None,
region=None, aws_access_key_id=None, aws_secret_access_key=None
)GenericS3 datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
MySQL
class domino_data.data_sources.MySQLConfig(
*, database=None, datetime_precision=None, region=None,
username=None, password=None, aws_access_key_id=None, aws_secret_access_key=None,
aws_session_token=None
)MySQL datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Oracle
class domino_data.data_sources.OracleConfig(
*, database=None, datetime_precision=None, username=None,
password=None, client_cert=None, client_key=None, ca_cert=None
)Oracle datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Palantir
class domino_data.data_sources.PalantirConfig(
*, datetime_precision=None, client_id=None, client_secret=None,
o_auth_token=None
)Palantir datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
PostgreSQL
class domino_data.data_sources.PostgreSQLConfig(
*, database=None, datetime_precision=None, region=None,
username=None, password=None, aws_access_key_id=None, aws_secret_access_key=None,
aws_session_token=None, client_cert=None, client_key=None, ca_cert=None
)PostgreSQL datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Redshift
class domino_data.data_sources.RedshiftConfig(
*, database=None, datetime_precision=None, region=None,
username=None, password=None, aws_access_key_id=None, aws_secret_access_key=None,
aws_session_token=None
)Redshift datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
S3
class domino_data.data_sources.S3Config(
*, bucket=None, subfolder=None, region=None,
aws_access_key_id=None, aws_secret_access_key=None, aws_session_token=None
)S3 datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Snowflake
class domino_data.data_sources.SnowflakeConfig(
*, datetime_precision=None, database=None, role=None,
schema=None, warehouse=None, username=None, private_key=None,
passphrase=None, password=None, token=None
)Snowflake datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trino
class domino_data.data_sources.TrinoConfig(
*, catalog=None, datetime_precision=None, schema=None,
username=None, password=None
)Trino datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
Below are examples of Data Sources and their configurable override options for v6.7.3 of the Domino Data API.
The source code for these class definitions is available on GitHub.
Work with Data Source Connectors has instructions on how to set up the Data Sources.
Databricks
class domino_data.data_sources.DatabricksConfig(
*, datetime_precision=None, catalog=None, schema=None,
personal_access_token=None
)Databricks datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
DB2Native
class domino_data.data_sources.DB2NativeConfig(
*, database=None, datetime_precision=None, username=None,
password=None, dsn=None
)DB2Native datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
GenericS3
class domino_data.data_sources.GenericS3Config(
*, bucket=None, subfolder=None, host=None,
region=None, aws_access_key_id=None, aws_secret_access_key=None
)GenericS3 datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
MySQL
class domino_data.data_sources.MySQLConfig(
*, database=None, datetime_precision=None, region=None,
username=None, password=None, aws_access_key_id=None, aws_secret_access_key=None,
aws_session_token=None
)MySQL datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Oracle
class domino_data.data_sources.OracleConfig(
*, database=None, datetime_precision=None, username=None,
password=None, client_cert=None, client_key=None, ca_cert=None
)Oracle datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Palantir
class domino_data.data_sources.PalantirConfig(
*, datetime_precision=None, client_id=None, client_secret=None,
o_auth_token=None
)Palantir datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
PostgreSQL
class domino_data.data_sources.PostgreSQLConfig(
*, database=None, datetime_precision=None, region=None,
username=None, password=None, aws_access_key_id=None, aws_secret_access_key=None,
aws_session_token=None, client_cert=None, client_key=None, ca_cert=None
)PostgreSQL datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Redshift
class domino_data.data_sources.RedshiftConfig(
*, database=None, datetime_precision=None, region=None,
username=None, password=None, aws_access_key_id=None, aws_secret_access_key=None,
aws_session_token=None
)Redshift datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
S3
class domino_data.data_sources.S3Config(
*, bucket=None, subfolder=None, region=None,
aws_access_key_id=None, aws_secret_access_key=None, aws_session_token=None
)S3 datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Snowflake
class domino_data.data_sources.SnowflakeConfig(
*, datetime_precision=None, database=None, role=None,
schema=None, warehouse=None, username=None, private_key=None,
passphrase=None, password=None, token=None
)Snowflake datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trino
class domino_data.data_sources.TrinoConfig(
*, catalog=None, datetime_precision=None, schema=None,
username=None, password=None
)Trino datasource configuration.
| Parameter | Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
