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 table 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.