[Feature] Test for date_spine should remove adapter-specific logic

[dbeatty10]

Housekeeping

• I am a maintainer of dbt-adapters

Short description

The test for the cross-adapter date_spine macro within fixture_date_spine.py contains adapter-specific logic like {% if target.type == 'postgres' %} that should be in dbt-postgres instead.

Context

History: this test was migrated effectively as-is from dbt-utils to dbt-core to dbt-adapters. But now we'll probably want to clean it up a bit.

Acceptance criteria

Tasks

Beta Give feedback

1. The test definition in dbt-adapters contains no adapter-specific logic like {% if target.type == 'postgres' %}
2. Rather, adapters like dbt-postgres can override the test as-needed

Testing

Tasks

Beta Give feedback

1. Test in dbt-postgres
2. Test in dbt-bigquery
3. Test in dbt-redshift
4. Test in dbt-snowflake
5. Test in dbt-spark

Security

No security concerns.

Docs

No doc updates needed.

Consequences

This change impacts any adapter that imports this test.

Depending on the final implementation in dbt-adapters, the adapter types that are currently hard-coded (postgres, bigquery, redshift) may need to provide overrides of the text fixtures as a result of this change.