Refresh_external_table not working

[ralz29]

Describe the bug

Adding dbt_external_tables.refresh_external_table() doesn't work and throws various issues

Steps to reproduce

Added
pre_hook = "{{ dbt_external_tables.refresh_external_table('schema.table') }}"
or
pre_hook = "{{ dbt_external_tables.refresh_external_table('table') }}"
also tried
pre_hook = "{{ dbt_external_tables.refresh_external_table(source('schema', 'table')) }}"
and
pre_hook = "{{ dbt_external_tables.refresh_external_table(ref('table')) }}"

Expected results

The external table to get refreshed

Actual results

In the first two instances I got
` 'str object' has no attribute 'external'

in macro refresh_external_table (macros/common/refresh_external_table.sql)`

and in the second I got

` 'dbt.adapters.snowflake.relation.SnowflakeRelation object' has no attribute 'external'

in macro refresh_external_table (macros/common/refresh_external_table.sql)`

System information

The contents of your packages.yml file:

https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/

• package: dbt-labs/dbt_external_tables
  version: 0.11.1

Which database are you using dbt with?

• snowflake

The output of dbt --version:

1.9.4

The output of python --version:
3.11

[jeremyyeo]

Hey @ralz29 - do you actually have a real source with the external key declared - ala https://github.com/dbt-labs/dbt-external-tables/blob/main/sample_sources/snowflake.yml#L13 ? Seems like you're attempting to do things that's not meant to be done - like using ref() - which is for a table and not a source.