Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Unidentified custom TAG to schedule executions with workflow configurations in Dataform

I'm trying to select the custom tag "business_daily_twice_7" that I added in the "dim_contacts.sqlx" file of my repository in the main branch. But this option doesn't appear in the drop-down "Workflow configurations" as instructed in the documentation Schedule executions with workflow configurations. Am I making a mistake? What can I do?

print_1.png

print_2.png

Solved Solved
1 2 130
1 ACCEPTED SOLUTION

Here's a breakdown of potential issues and how to address them:

Potential Causes:

  1. Syntax & Formatting:

    • Configuration Block: Ensure correct syntax within the dim_contacts.sqlx configuration block, including proper comma placement and tag capitalization (case-sensitive).
    • SQL Syntax: Double-check for general SQL syntax errors throughout the file.
  2. Dataform Synchronization:

    • Repository State: Verify that your changes to dim_contacts.sqlx have been committed and pushed to the main branch. Dataform's UI displays tags based on the current repository state.
  3. Tag Propagation:

    • Dependency Errors: Any errors in dim_contacts.sqlx or its dependent SQLX files could prevent Dataform from recognizing and propagating the tag.
  4. Caching:

    • Outdated UI Data: Clear your browser cache to eliminate the possibility of outdated information. For a more thorough reset, try a hard refresh (Ctrl+F5 or Cmd+Shift+R on most browsers).
  5. Workflow UI Limitations:

    • Tag Complexity: Exceptionally long tags or those with special characters might have issues displaying in the dropdown (though this would be an unusual case).

Troubleshooting Steps:

  1. Examine Syntax: Meticulously review dim_contacts.sqlx for any syntax errors, especially within the configuration block. Be mindful of formatting.

  2. Force Refresh: Manually refresh your Dataform workspace. Then, confirm that your changes to dim_contacts.sqlx are visible in your repository's main branch.

  3. Clear Cache: Follow your browser's specific instructions for clearing the cache.

  4. Inspect Dependencies: Thoroughly examine any SQLX files that dim_contacts depends on, ensuring they are free of errors and referenced correctly.

  5. Test Simpler Tag: Create a temporary tag using standard naming conventions (e.g., "test_tag") to see if this simpler tag appears in the dropdown

View solution in original post

2 REPLIES 2

Here's a breakdown of potential issues and how to address them:

Potential Causes:

  1. Syntax & Formatting:

    • Configuration Block: Ensure correct syntax within the dim_contacts.sqlx configuration block, including proper comma placement and tag capitalization (case-sensitive).
    • SQL Syntax: Double-check for general SQL syntax errors throughout the file.
  2. Dataform Synchronization:

    • Repository State: Verify that your changes to dim_contacts.sqlx have been committed and pushed to the main branch. Dataform's UI displays tags based on the current repository state.
  3. Tag Propagation:

    • Dependency Errors: Any errors in dim_contacts.sqlx or its dependent SQLX files could prevent Dataform from recognizing and propagating the tag.
  4. Caching:

    • Outdated UI Data: Clear your browser cache to eliminate the possibility of outdated information. For a more thorough reset, try a hard refresh (Ctrl+F5 or Cmd+Shift+R on most browsers).
  5. Workflow UI Limitations:

    • Tag Complexity: Exceptionally long tags or those with special characters might have issues displaying in the dropdown (though this would be an unusual case).

Troubleshooting Steps:

  1. Examine Syntax: Meticulously review dim_contacts.sqlx for any syntax errors, especially within the configuration block. Be mindful of formatting.

  2. Force Refresh: Manually refresh your Dataform workspace. Then, confirm that your changes to dim_contacts.sqlx are visible in your repository's main branch.

  3. Clear Cache: Follow your browser's specific instructions for clearing the cache.

  4. Inspect Dependencies: Thoroughly examine any SQLX files that dim_contacts depends on, ensuring they are free of errors and referenced correctly.

  5. Test Simpler Tag: Create a temporary tag using standard naming conventions (e.g., "test_tag") to see if this simpler tag appears in the dropdown

Thank you so much, @ms4446, the problem was the cache. I cleared it and the tag was visible in the workflow configuration.