Skip to main content

What does Atlan crawl from Dremio

TL;DR

Learn what assets and metadata Atlan crawls from Dremio data lakehouse.

Connect

Atlan crawls metadata from your Dremio data lakehouse—physical datasets, virtual datasets, folders, spaces, and sources—and builds column-level lineage from each virtual dataset's SQL definition.

Assets

Atlan crawls the following Dremio assets, each with specific metadata fields.

DremioSpace

Dremio Spaces represent logical workspaces where users create and organize virtual datasets.

Source fieldAtlan fieldDescription
namenameSpace name
iddremioIdUnique identifier for the space in Dremio

DremioSource

Dremio Sources represent external data connections providing access to various systems.

Source fieldAtlan fieldDescription
namenameSource name
typedremioSourceTypeType of external source connection
configdremioSourceConnectionConfigsConfiguration parameters for connecting to the external source
accelerationGracePeriodMs, accelerationRefreshPeriodMs, accelerationRefreshSchedule, accelerationActivePolicyType, accelerationNeverExpire, accelerationNeverRefreshdremioSourceAccelerationSettingsAcceleration settings including grace period, refresh settings, and policy configuration
metadataPolicydremioSourceMetadataPoliciesMetadata policy settings for the source
iddremioIdUnique identifier for the source in Dremio

DremioFolder

Dremio Folders represent organizational containers within spaces or sources.

Source fieldAtlan fieldDescription
namenameFolder name
iddremioIdUnique identifier for the folder in Dremio

Physical Dataset

Physical datasets represent tables from connected data sources available in Dremio.

Source fieldAtlan fieldDescription
namenamePhysical dataset name
rowCountrowCountNumber of rows in the dataset
columnCountcolumnCountNumber of columns in the dataset
createdAtsourceCreatedAtWhen the physical dataset was created
iddremioIdUnique identifier for the dataset in Dremio

Virtual Dataset

Virtual datasets represent virtual tables created in Dremio through data virtualization.

Source fieldAtlan fieldDescription
namenameVirtual dataset name
sqldefinitionSQL definition of the virtual dataset
createdAtsourceCreatedAtWhen the virtual dataset was created
iddremioIdUnique identifier for the dataset in Dremio
rowCountrowCountNumber of rows in the dataset
columnCountcolumnCountNumber of columns in the dataset

Column

Columns represent individual fields within physical and virtual datasets.

Source fieldAtlan fieldDescription
namenameColumn name
typedataTypeColumn data type
isNullableisNullableWhether the column permits null values
iddremioIdUnique identifier for the column in Dremio
isPrimaryKeyisPrimaryKeyWhether the column is a primary key
isPartitionColumnisPartitionColumnWhether the column is a partition column
ordinalPositionordinalPositionPosition of the column in the table
precisionprecisionPrecision of the column
scalescaleScale of the column

Lineage

Atlan builds lineage for Dremio by parsing each virtual dataset's SQL definition:

  • Virtual-to-physical (intra-Dremio): each virtual dataset is linked to the physical datasets—and upstream virtual datasets—it selects from, including multi-hop virtual-to-virtual chains.
  • Cross-connector upstream: a Dremio physical dataset is linked to the real source table already in Atlan—AWS Glue and Iceberg tables (lakehouse) and relational tables such as Snowflake, PostgreSQL, or Redshift—when you select the source connection under Advanced Configuration during crawler setup and that source is crawled in Atlan.

Atlan also builds column-level lineage for Dremio:

  • Source column to physical dataset column: a physical dataset mirrors its source table, so each of its columns is linked to the matching column on the upstream source asset in Atlan.
  • Column to virtual dataset column: each virtual dataset's SQL is parsed per column, so a virtual dataset column is linked to every column it's derived from, including through expressions and joins.

Requirements:

  • The crawling role needs SELECT on the datasets whose SQL is parsed (granted during setup—reading each view's SQL definition from INFORMATION_SCHEMA.VIEWS).
  • For cross-connector upstream lineage, table-level and column-level, the upstream source connection must already exist in Atlan, and you must select it under Advanced Configuration.
  • The virtual dataset and the datasets it selects from must be included in the same crawl. Assets outside the crawl's scope are skipped.
  • Column-level lineage requires the virtual dataset's SQL to name its columns. A virtual dataset defined as SELECT * receives table-level lineage only.