...
Tables provides a JDBC-based interface for reading and writing datasets in ADLS or WASB. Using the underlying JDBC connection, you can access your ADLS or WASB data like a relational datastore, run jobs against it, and write results back to the datastore as JDBC tables.D s conntype type databricks - Your connection to
Tables leverages the SSO authentication that is native toD s conntype type databricks
.D s conntype type databricks - For more information on Azure
Tables, see https://docs.microsoft.com/en-us/azure/databricks/data/tables.D s conntype type databricks
- For more information on Azure
Supported Environments:
Operation |
| Amazon | Microsoft Azure | |
---|---|---|---|---|
Read | Not supported | Supported | Supported | |
Write | Not supported | Supported | Supported |
Limitations
- Ad-hoc publishing of generated results to
Tables is not supported.D s conntype type databricks - Integration with Kerberos or secure impersonation is not supported.
- Some table types and publishing actions are not supported.
- Access to external Hive metastores is not supported.
...
D s config Locate the following parameter and set it to
true
:Code Block "feature.databricks.connection.enabled": true,
To allow for direct publishing of job results to
tables from the Run Job page, you must enable the following parameters. For more information on these settings, see Databricks Tables Table Settings.D s conntype type databricks Parameter Description feature.databricks.enableDeltaTableWrites Set this value to
true
to enable users to choose to write generated results to
delta tables from the Run Job page.D s conntype type databricks feature.databricks.enableExternalTableWrites Set this value to
true
to enable users to choose to write generated results to
external tables from the Run Job page.D s conntype type databricks Save your changes and restart the platform.
...
- Create datasets by reading from Databricks Tables tables.
- Write data to Databricks Tables.
Table Type | Support | Notes | |||
---|---|---|---|---|---|
Databricks managed tables | Read/Write | ||||
Delta tables | Read/Write |
| |||
External tables | Read/Write |
| |||
Databricks unmanaged tables | Read/Write | ||||
Delta Tables (managed and unmanaged tables) | Read/Write | ||||
Partitioned tables | Read |
The underlying format for Databricks Tables is Parquet.
...
Supported Versions: n/a
Supported Environments:
Operation |
| Amazon | Microsoft Azure | |
---|---|---|---|---|
Read | Not supported | Supported | Supported | |
Write | Not supported | Supported | Supported |
Tip |
---|
Tip: It's easier to create a connection of this type through the UI. Typically, only one connection is needed. |
...