SQL query error

0
Hi everyone,   snowflake with medix connection has done. I'm using SF_Showcase app which is available in mendix marketplace. when i try to execute cortex analyst query i m getting below error..      i have added semantic model in STAGE of the respective database and schema ....for your reference the semantic model is..   name: Historical Sales Datadescription: This semantic model is used for analyzing historical sales data across different stores, including details about items sold, weather conditions, and holiday impact. tables:  - name: historical_sales_data    description: Captures historical sales data across different store locations, including sales figures, weather conditions, and holidays.     base_table:      database: DATABASE_SHOWCASE      schema: SCHEMA_SHOWCASE      table: historical_sales_data     dimensions:      - name: store_id        synonyms: ["store", "location_id"]        description: The unique identifier for the store.        expr: store_id        data_type: NUMBER        unique: false        sample_values: ["1", "2"]       - name: item        synonyms: ["product", "item_name"]        description: The name of the item sold.        expr: item        data_type: VARCHAR        unique: false        sample_values: ["jacket", "umbrella"]       - name: temperature        synonyms: ["temp", "weather_temperature"]        description: The temperature at the time of sale.        expr: temperature        data_type: NUMBER        unique: false        sample_values: ["22", "30"]       - name: humidity        synonyms: ["humidity_level", "weather_humidity"]        description: The humidity level at the time of sale.        expr: humidity        data_type: FLOAT        unique: false        sample_values: ["0.3", "0.1"]       - name: holiday        synonyms: ["holiday_name", "festival"]        description: The holiday on which the sale took place.        expr: holiday        data_type: VARCHAR        unique: false        sample_values: ["Christmas", "New Year`s Day"]       - name: label        synonyms: ["is_special", "is_promotional"]        description: A boolean indicating if the sale is special or promotional.        expr: label        data_type: BOOLEAN        unique: false        sample_values: ["true", "false"]     time_dimensions:      - name: sale_date        synonyms: ["sale_time", "transaction_date"]        description: The timestamp when the sale occurred.        expr: date        data_type: TIMESTAMP        unique: false     measures:      - name: sales        synonyms: ["sales_value", "revenue"]        description: The amount of sold items.        expr: sales        data_type: FLOAT        default_aggregation: sum     filters:      - name: holiday_sales        synonyms: ["holiday", "festival"]        description: Filter to restrict data to sales made on holidays.        expr: holiday IS NOT NULL       - name: non_promotional_sales        synonyms: ["regular_sales", "standard_sales"]        description: Filter to exclude special or promotional sales.        expr: label = false       - name: clothing        synonyms: ["Clothes", "Clothing", "Clothing item", "Garments"]        description: A filter to restrict only to clothing items.        expr: item IN ("jacket", "pants", "shirt", "socks")   Anyone please help me with this..    
asked
0 answers