Source Product Offer Countries Data Block

The Source Product Offer Countries (Source_ProductOfferCountries) Data Block is an Source Data Block and is expected to be edited.

The Product Offer Countries (Source_ProductOfferCountries) Data Block retrieves product and country code data from the PRODUCTOFFEREDCOUNTRIESANDCLIENTS table from Assette’s Demo Snowflake database. The Data Block fetches the ProductCode and CountryCode columns for all records in the table and returns the results as a data table. This Data Block must be edited to get the relevant information from the client’s data source.

General Info #

The following table shows the default fields of the Data Block.

Field	Value
Name	Source_ProductOfferCountries
Block Category	Interface
Block Type	Snowflake Database Call
Data Category	None
Output Type	Data Table
Editable	True

Dependencies #

The following table shows the default dependencies of the Data Block.

Data Block	Description
DemoCertificate	The Snowflake Demo Certificate (DemoCertificate) Data Block is a constant Data Block which contains the private key for the Snowflake Tutorial. It is expected that this Data Block either be changed or removed to conform to the needs of the specific implementation. [Link]
DEMO_SnowFlakeSettingBlock	The Demo Snowflake Setting (DEMO_SnowFlakeSettingBlock) Data Block is used to facilitate access the Assette Demo Snowflake Data Warehouse by providing values for ‘user’, ‘account’, ‘warehouse’, etc. This Data Block must be edited or removed as dictated by the client’s data needs. [Link]

Columns #

None

Example Definition #

{
    "type": "table",
    "sql": "SELECT ProductCode, CountryCode FROM DEMO_DB.DBO.PRODUCTOFFEREDCOUNTRIESANDCLIENTS",
    "parameters": []
}

Example Request #

The following code shows an example request using the default values of the Data Block.

{}

Example Response #

The following code shows an example response using the default values of the Data Block. The default data source is the Assette Snowflake Demo Instance. The response may be shortened for brevity.

{
    "data": [
        {
            "PRODUCTCODE": "PRDK01",
            "COUNTRYCODE": "us"
        },
        {
            "PRODUCTCODE": "PRDK02",
            "COUNTRYCODE": "us"
        }
    ],
    "errors": [],
    "success": true,
    "logs": []
}