@s could you please help looking at this PR? https://github.com/airbytehq/airbyte/pull/802 I've merged and pushed back the changes to put Charles' branches and mine together for the normalization process... However I've ran into a last stop block where i have to run with a bunch of excludes:

gradlew build -x spotlessSql -x spotlessSqlApply -x spotlessSqlCheck

to make it build successfully... (Spotless is messing up the DBT SQL code turning into syntax errors otherwise...) Thanks!

looking

We should exclude spotless from those dirs

yeah can you add it as an exclude pattern in the root build.gradle?

Could you teach me how? 🤔 do I need to write:

gradle.startParameter.excludedTaskNames << "spotlessSql"

or something like that?

in the root build.gradle file (in the airbyte project root) you’ll find a block of code that looks like this:

spotless {
.
.
.
    sql {
        target '**/*.sql'
        targetExclude "**/build/**/*", "**/.gradle/**/*", "**/.venv/**"

        dbeaver().configFile(rootProject.file('tools/gradle/codestyle/sql-dbeaver.properties'))
    }
....

so we’d just need to add a pattern under

targetExclude

for the

sql

block that ignores DBT sql files

I hope your PR handles this case @Michel!!

it doesn't, can you point me to the github directory where these files are?

it’s on a branch. Here’s a branch example: https://github.com/airbytehq/airbyte/tree/chris/dbt and the path is https://github.com/airbytehq/airbyte/blob/chris/dbt/airbyte-integrations/bases/base-normalization/dbt-project-template/macros/cross_db_utils/json_operations.sql