Updates for dbt-py models on Snowpark

[jtcohen6]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/docs/build/python-models#specific-data-platforms

What part(s) of the page would you like to see updated?

Thanks to dbt-labs/dbt-snowflake#334, we can remove this entire section:

About "sprocs": dbt submits Python models to run as stored procedures, which some people call sprocs for short. By default, dbt will create a named sproc containing your model's compiled Python code, and then call it to execute. Snowpark has an Open Preview feature for temporary or anonymous stored procedures (docs), which are faster and leave a cleaner query history. You can switch this feature on for your models by configuring use_anonymous_sproc: True. We plan to switch this on for all dbt + Snowpark Python models starting with the release of dbt Core version 1.4.

We also need to add docs about imports (added in dbt-labs/dbt-snowflake#263). See Slack message for example use case. User can configure like so:

def model(dbt, session):
    dbt.config(
        materialized = "table",
        packages = ["numpy", "pandas", "word2number"],
        imports = ('@packages/word2number.zip' ),
        tags=['daily']
    )

Additional information

No response