version: 2
models:
  - name: silver__pool_metadata
    tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - MODULE
            - POOL_ID
    columns:
      - name: MODULE
        description: "{{ doc('pool_module') }}"
        tests:
          - not_null
          - dbt_expectations.expect_column_values_to_be_in_type_list:
              column_type_list:
                - STRING
                - VARCHAR
      - name: POOL_CREATED_BLOCK_ID
        description: "{{ doc('block_id') }}"
        tests:
          - not_null
          - dbt_expectations.expect_column_values_to_be_in_type_list:
              column_type_list:
                - NUMBER    
                - FLOAT  
      - name: POOL_CREATED_BLOCK_TIMESTAMP
        description: "{{ doc('block_timestamp') }}"
        tests:
          - not_null
          - dbt_expectations.expect_column_values_to_be_in_type_list:
              column_type_list:
                - TIMESTAMP_NTZ
      - name: POOL_ID
        description: "{{ doc('pool_id') }}"
        tests: 
          - not_null
          - dbt_expectations.expect_column_values_to_be_in_type_list:
              column_type_list:
                - NUMBER
                - FLOAT
      - name: POOL_ADDRESS
        description: "{{ doc('pool_address') }}"
      - name: ASSETS
        description: "{{ doc('pool_assets') }}"
        tests:
          - dbt_expectations.expect_column_values_to_be_in_type_list:
              column_type_list:
                - OBJECT
                - ARRAY