[ADAP-731] Add Support for External Network Locations

[davesgonechina]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

The capability to allow access to external network locations (e.g. dbt API endpoints) is now in private preview. This feature would allow Python models in dbt to make use of external access integrations created separately in Snowflake by adding the following to the implementation:

external_access_integrations = parsed_model["config"].get("external_access_integrations", [])
external_access_integrations = "', '".join(pexternal_access_integrations)

`EXTERNAL_ACCESS_INTEGRATIONS = ({external_access_integration})`

A user would add dbt.config(external_access_integrations = ["dbt_api_integration", "bi_tool_api_integration"]) to their Python model to use this capability.

Describe alternatives you've considered

The alternative would be to build the UDF without using dbt.

Who will this benefit?

At present, only Snowflake users who have use for this capability and, more importantly, have access to the Private Preview. As this feature moves to General Availability, the number of potential users grow.

The specific use case behind the creation of this issue is the desire to place the contents from the dbt Cloud API endpoint v2/accounts/{accountId}/jobs/ into a model for operational visibility on job schedules and upcoming run times.

Are you interested in contributing this feature?

Yes, time permitting. I've not contributed to a dbt adapter package before.

Anything else?

No response

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

[ernestoongaro]

Hi @mikealfare -- this was closed as Done, but I see a new issue #925, was this implemented?

[Lindblomsebastian]

Does this add support for secrets as well?