Advanced

Configuring a Source Database for CDC

This article is part of a series on CDC in Matillion ETL The CDC function that Matillion ETL offers is reliant on AWS DMS. Part of the usual DMS setup means configuring...

Google Adwords Data Model Views (201802)

AccountPerformance AdCustomizersFeedItem AdgroupPerformance AdPerformance AgeRangePerformance AudiencePerformance AutomaticPlacementsPerformance BidGoalPerformance BudgetPerformance CallMetricsCallDetails CampaignAdScheduleTarget CampaignCriteria CampaignGroupPerformance CampaignLocationTarget CampaignNegativeKeywordsPerformance CampaignNegativeLocations CampaignNegativePlacementsPerformance CampaignPerformance CampaignSharedSet ClickPerformance CreativeConversion CriteriaPerformance Customers DestinationUrl DisplayKeywordPerformance DisplayTopicsPerformance FinalUrl GenderPerformance GeoPerformance KeywordlessCategory KeywordlessQuery KeywordsPerformance...

Google Adwords Data Model Views (201806)

AccountPerformance AdCustomizersFeedItem AdgroupPerformance AdPerformance AgeRangePerformance AudiencePerformance AutomaticPlacementsPerformance BidGoalPerformance BudgetPerformance CallMetricsCallDetails CampaignAdScheduleTarget CampaignCriteria CampaignGroupPerformance CampaignLocationTarget CampaignNegativeKeywordsPerformance CampaignNegativeLocations CampaignNegativePlacementsPerformance CampaignPerformance CampaignSharedSet ClickPerformance CreativeConversion CriteriaPerformance Customers DestinationUrl DisplayKeywordPerformance DisplayTopicsPerformance FinalUrl GenderPerformance GeoPerformance KeywordlessCategory KeywordlessQuery KeywordsPerformance...

Google Adwords Data Model Views (201809)

AccountPerformance AdCustomizersFeedItem AdgroupPerformance AdPerformance AgeRangePerformance AudiencePerformance AutomaticPlacementsPerformance BidGoalPerformance BudgetPerformance CallMetricsCallDetails CampaignAdScheduleTarget CampaignCriteria CampaignGroupPerformance CampaignLocationTarget CampaignNegativeKeywordsPerformance CampaignNegativeLocations CampaignNegativePlacementsPerformance CampaignPerformance CampaignSharedSet ClickPerformance CreativeConversion CriteriaPerformance Customers DisplayKeywordPerformance DisplayTopicsPerformance FinalUrl GenderPerformance GeoPerformance KeywordlessCategory KeywordlessQuery KeywordsPerformance Label...

Job Concurrency

Related Topic: Parallelism with Matillion ETL for Redshift Overview This article addresses the limits of Matillion ETL Job queues and concurrently run. An overview of Matillion ETL's process of running Jobs is...

Connecting To Any REST API

Overview Matillion can extract and load data from most JSON and XML-based REST APIs, and also from some SOAP APIs (those which behave RESTfully). Good positive indicators are: You can get data...

Connecting To Any REST API - Examples

Below we give an example for Connecting to a REST API. Example 1: Salesforce Lighting - Find the API documentation Salesforce publish this article and this guide on how to find your...

API v1 - Schedules

Below are common example commands to Export and Import schedules. Please note that you cannot import into “default” version. Exporting Export ALL Schedules in a Project To export all schedules from a...

Splunk 3rd Party Data Model

Connection String Options Auto Cache Batch Size Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Connection Life Time Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type...

Product Improvement Metrics

As of version 1.38.0, Matillion ETL comes with Product Improvement Metrics, a system that can gather anonymized data seamlessly in the background of the client. This data, if enabled, will be periodically...