Page tree

Release 7.1.2


Contents:

   

Use this browser to read sources stored as the Databricks database tables and views or select or create tables to which to publish job results.

  • Your Alteryx® deployment must be installed on Azure and connected to an instance of Databricks Tables.

    NOTE: Each user must have a Databricks Personal Access Token installed in their account. For more information, see Databricks Personal Access Token Page.

  • The Databricks Tables browser appears when you select the Databricks Tables tab to import a dataset. See Import Data Page.
  • When specifying a job, you can choose to write a publishing action to Databricks Tables. See Run Job Page.
  • For more information on interacting with Databricks Tables, see Using Databricks Tables.

Figure: Databricks Tables Browser

Browse Databricks Tables

Use the links and icons to browse for Databricks databases and tables.

NOTE: Row information is not available for Databricks tables.


NOTE: Azure Databricks does not publish the last modified date for its resources. This information is not available to the Designer Cloud Powered by Trifacta platform.


NOTE: Avoid using the Back button on your browser, which exits the browser without applying changes to your configuration.

IdentifierTypeDescription
Database

Click these links to open a Databricks database to reveal its tables.

Table

Click the Plus icon to select this Databricks table as your source.

To preview its data, hover over the name of the table, and then click the Eye icon.

Tip: Sizes are calculated and displayed next to tables. They are not displayed next to databases.

NOTE: Timestamp information is not available from Databricks.

View

Click the Plus icon to select this view as your source.

To preview its data, hover over the view name and then click the Eye icon.

NOTE: Previewing complex views may impact performance.

Page navigation

Use these links to navigate between pages of databases and tables.

NOTE: In some cases, subsequent pages of tables may be blank, and counts of tables may not match displayed figures. This is a known issue.

Breadcrumb

Click the links in the breadcrumb trail to navigate.

Search List

To filter the list of databases or tables, enter a string in the Search box. The filter is applied as you type and matches anywhere in the name of a currently displayed database or table name.

Create Dataset with SQL

Creation of datasets with SQL is not supported for Databricks Tables connections.

This page has no comments.