Advanced

API v1 - Audit

The Audit endpoint is of singular function usable only by users running an Enterprise Edition Matillion ETL instance. Your Audit Log can be downloaded using the API via: curl -X GET -o...

Facebook Data Model Changes

The following changes to the Facebook Query's Connection Options and Data Sources have occurred since its last version: Note: We apologise that this does not yet include changes to specific columns. We...

DoubleClick For Publishers 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...

API v1 - APIProfile

This article belongs to series on API Profiles and the Matillion ETL v1 API. The APIProfile endpoint allows users to manage their API Profiles similarly to how they can be accessed inside...

Scope of Matillion ETL Features

Matillion ETL has many features that are not configured globally and can differ from Project to Project. For example, saved Passwords are unique to the Project they are created in and cannot...

Google 3rd Party Oauth using Service Accounts

For other options on authenticating Google 3rd Party services, see here. Overview Matillion provides various components to pull data from Google Services like Adwords, Google Analytics, Youtube, etc. One has to register...

Migrate

Overview The Migration tool allows users to quickly and easily send Matillion ETL resources from one Matillion Instance to another. The Migrate menu can be reached via the main Project menu from...

DMS Migration Instances

This article is part of a series on CDC in Matillion ETL In order to use the CDC function in Matillion ETL, you must have already started a Replication Instance on your...

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...