Snowflake-integrated applications

name
AppTemplate Snowflake Integration for Marketing
tag
DWH／Snowflake
Connector used
Snowflake Connector
Conceptual diagram of Snowflake integration applications

Use Snowflake to:

  • Processing to store and retrieve data generated by the MA solution

This application includes:

script

  • Salesforce Account Information Registration Script
  • SHANON MARKETING PLATFORM Contact Company Information Registration Script
  • Adobe Marketo Engage Contact Company Information Registration Script
  • e-Stat government statistical information registration script
  • Company information search target extraction script
  • Company information search result registration script
  • Company information output script for SFA & MA updates
  • Script for creating a summary of Azure OpenAI Service input statistics
  • Azure OpenAI Service query result registration script
  • This application requires HULFT Square Connector for Snowflake.

How to install and use it

Script Details

Salesforce Account Information Registration Script (Snowflake_from_SFA)

Image diagram of the Salesforce account information registration script (Snowflake_from_SFA)

Reads a CSV file of company information obtained from Salesforce and stores it in a Snowflake table.
Additionally, information such as client names and phone numbers, which are required when searching for company information, is stored in a Snowflake search table.

SHANON MARKETING PLATFORM Contact Company Information Registration Script (Snowflake_from_SHANON)

Image diagram related to the SHANON MARKETING PLATFORM contact company information registration script (Snowflake_from_SHANON).

Reads a CSV file of company information obtained from Salesforce and stores it in a Snowflake table.
Additionally, information such as client names and phone numbers, which are required when searching for company information, is stored in a Snowflake search table.

Adobe Marketo Engage Contact Company Information Registration Script (Snowflake_from_Marketo)

Image diagram related to the Adobe Marketo Engage contact company information registration script (Snowflake_from_Marketo).

Reads a CSV file of company information obtained from Adobe Marketo Engage and stores it in a Snowflake table.
Additionally, information such as client names and phone numbers, which are required when searching for company information, is stored in a Snowflake search table.

e-Stat Government Statistics Information Registration Script (Snowflake_from_e-Stat_0000010103)

Image diagram related to the e-Stat government statistics information registration script (Snowflake_from_e-Stat_0000010103)

Reads a CSV file of government statistical information obtained from Adobe Marketo Engage and stores it in a Snowflake table.

Company information search target extraction script (Snowflake_to_CORP_INFO)

Image diagram of the corporate information search target extraction script (Snowflake_to_CORP_INFO)

From the Snowflake table that stores company information obtained from Salesforce, SHANON MARKETING PLATFORM, and Adobe Marketo Engage, extract company code, company name, and phone number data and output it to a CSV file.

Company information search result registration script (Snowflake_from_CORP_INFO)

Image diagram of the corporate information search result registration script (Snowflake_from_CORP_INFO)

Store company information search results in Snowflake.

Company information output script for SFA & MA updates (Snowflake_to_SFA_and_MA)

Image diagram related to the corporate information output script for SFA & MA updates (Snowflake_to_SFA_and_MA)

From the company information search results stored in Snowflake, data for which company information is not registered in SFA/MA is output to a CSV file.

Azure OpenAI Service Statistical Information Summary Creation Script (Snowflake_to_e-Stat_for_AOAI)

Image diagram of the script for creating statistical information summaries for Azure OpenAI Service submission (Snowflake_to_e-Stat_for_AOAI).

Extract data for the Kanto region from the Snowflake table that stores government statistical information obtained from e-Stat and create a CSV file to input into AOAI.

Azure OpenAI Service query result registration script (Snowflake_from_AOAI)

Image diagram of the Azure OpenAI Service query result registration script (Snowflake_from_AOAI)

The response from AOAI is stored in Snowflake.

How to install and use it