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