Thomas Schmidt Somtom

## football_pitch.geojson

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                Somtom
                / football_pitch.geojson
            
            
              Last active
              June 16, 2024 08:49
            
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## data_regression_example__snapshot_data_diff.sql
/*
    This macro is used to generate a query for data regression diffs. The query
    compares new data (where dbt_valid_to is not null) to old data which is not valid
    anymore.
*/
{% macro
    snapshot_data_diff(
        table,
        unique_key,
        exclude=[

## data_regression_example__snapshot__fct_web_sessoins.sql
{% snapshot snapshot__fct_web_sessions %}

    {{
        config(
          target_schema=generate_schema_name('snapshots'),
          unique_key='session_id',
          strategy='check',
          check_cols = 'all',
          invalidate_hard_deletes=True
        )

## dbt_is_null_test_example.sql
/*
    Based on https://github.com/dbt-labs/dbt-labs-experimental-features/blob/master/snapshot-testing/macros/test_is_null.sql
*/
{% macro test_is_null(model, column_name) %}

SELECT *
FROM {{ model }}
WHERE {{ column_name }} IS NOT NULL

{% endmacro %}

## data_regression_example__historic_fct_web_sessions.sql
{% snapshot historic_fct_web_sessions %}

{{
    config(
      target_schema=generate_schema_name('snapshots'),
      unique_key='date',
      strategy='check',
      check_cols=[
        'duration_in_s',
        'page_views',
	/*
	This macro is used to generate a query for data regression diffs. The query
	compares new data (where dbt_valid_to is not null) to old data which is not valid
	anymore.
	*/
	{% macro
	snapshot_data_diff(
	table,
	unique_key,
	exclude=[
	{% snapshot snapshot__fct_web_sessions %}

	{{
	config(
	target_schema=generate_schema_name('snapshots'),
	unique_key='session_id',
	strategy='check',
	check_cols = 'all',
	invalidate_hard_deletes=True
	)
	/*
	Based on https://github.com/dbt-labs/dbt-labs-experimental-features/blob/master/snapshot-testing/macros/test_is_null.sql
	*/
	{% macro test_is_null(model, column_name) %}

	SELECT *
	FROM {{ model }}
	WHERE {{ column_name }} IS NOT NULL

	{% endmacro %}
	{% snapshot historic_fct_web_sessions %}

	{{
	config(
	target_schema=generate_schema_name('snapshots'),
	unique_key='date',
	strategy='check',
	check_cols=[
	'duration_in_s',
	'page_views',