Skip to content

[Bug] building UDFs should create my custom schema #12142

@graciegoheen

Description

@graciegoheen

Is this a new bug in dbt-core?

  • I believe this is a new bug in dbt-core
  • I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

i have a function with a custom schema defined:

functions:
  - name: is_positive_int
    description: My UDF that determines if a string represents a positive (+) integer
    config:
      schema: udf_schema
      volatility: deterministic        
    arguments:
      - name: a_string
        data_type: string 
        description: The string that I want to check if it's representing a positive integer (like "10") 
    returns: 
      data_type: integer 

when i go to build this, it says my custom schema does not exist:

Image

Expected Behavior

dbt should automatically create this schema, like it does for models:

Image

Which database adapter are you using with dbt?

snowflake

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions