Snowflake-integrated applications

name
AppTemplate Snowflake Integration for Marketing
tag
DWH／Snowflake
Connector used
Snowflake Connector

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)

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)

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)

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)

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)

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)

Store company information search results in Snowflake.

Company 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)

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)

The response from AOAI is stored in Snowflake.

How to install and use it