jinja2 - dbt run-operation to call macros that have non-string arguments

Question

Say that I want to drop the ajs schema as a clean up activity on our dev db, not as part of a regular dbt workflow

dbt run-operation drop_schema --args '{relation: ajs}'

perhaps I need to wrap drop_schema into another macro drop_schema_str(schema_str) where schema_str is the string of the schema and it is used to make a Relation object before invoking drop_schema()?

question from:https://stackoverflow.com/questions/65912839/dbt-run-operation-to-call-macros-that-have-non-string-arguments

Answer 1

create this macro

{% macro drop_schema_str(schema) %}
  {% set relation = api.Relation.create(database=target.database, schema=schema) %}
  {% do drop_schema(relation) %}
{% endmacro %}

then invoke it with

dbt run-operation drop_schema_str --args '{schema: ajs}'