dbt run fails if there are external BigQuery tables in same dataset

[improbable-benfischer]

Besides views and tables, BigQuery also supports tables of external type. When dbt materializes a model of a dataset (schema) that has external tables, it fails with

Invalid arguments passed to "BigQueryRelation" instance: property "type", 'external' is not one of ['table', 'view', 'cte', None]

Steps to reproduce

1. In a BigQuery project, create an external table foo.external_table (for example, use "Google Drive" as location and "Google Sheets" as file format).
2. Create a dbt project for this BigQuery project. Use foo as default schema.
3. Add a model models/foo/dbt_table.sql with any query, say SELECT 1 as bar.
4. Run

dbt run --models foo.dbt_table

Log message

Found 0 analyses, 56 macros, 0 tests, 55 models, 0 operations, 0 seed files, 0 archives

16:16:20 | Concurrency: 8 threads (target='development')
16:16:20 | 
16:16:20 | 1 of 1 START table model foo.dbt_table............................... [RUN]
16:16:21 | 1 of 1 ERROR creating table model foo.dbt_table...................... [ERROR in 0.72s]
16:16:21 | 
16:16:21 | Finished running 1 table models in 2.06s.

Completed with 1 errors:

Runtime Error in model dbt_table (models/foo/dbt_table.sql)
  Invalid arguments passed to "BigQueryRelation" instance: property "type", 'external' is not one of ['table', 'view', 'cte', None]

Done. PASS=0 ERROR=1 SKIP=0 TOTAL=1

Workaround

If there are no external tables in dataset foo, this works. So, moving foo.external_table to baz.external_table resolves the issue.

[drewbanin]

Thanks @improbable-benfischer, we'll take a look

[drewbanin]

Fixed in #828, closing