Skip to main content

external

models/<filename>.yml
version: 2

sources:
- name: <source_name>
tables:
- name: <table_name>
external:
location: <string>
file_format: <string>
row_format: <string>
tbl_properties: <string>
partitions:
- name: <column_name>
data_type: <string>
description: <string>
meta: {dictionary}
- ...
<additional_property>: <additional_value>

Definition

An extensible dictionary of metadata properties specific to sources that point to external tables. There are optional built-in properties, with simple type validation, that roughly correspond to the Hive external tableIn simplest terms, a table is the direct storage of data in rows and columns. Think excel sheet with raw values in each of the cells. spec. You may define and use as many additional properties as you'd like.

You may wish to define the external property in order to:

  • Power macros that introspect graph.sources
  • Define metadata that you can later extract from the manifest

For an example of how this property can be used to power custom workflows, see the dbt-external-tables package.

0
Loading