Stack Overflow
Stack Overflow

Questions tagged [matillion]

Matillion is a product which transforms businesses' data, across its various locations and forms, into cloud data warehouses to enable informed decision making.

Matillion is a product which transforms businesses' data, across its various locations and forms, into cloud data warehouses to enable informed decision making. https://www.matillion.com/

79 questions
0
votes
1 answer

Matillion ETL not launching

I am trying to launch a Matillion ETL instance through AWS and keep getting the error below ERROR: This site can’t be reached amazonaws.com took too long to respond ec2-34-226-233-122.compute-1.amazonaws.com This is the youtube video I follow.…
samthecodegod
  • 53
  • 4
0
votes
1 answer

Unable to set a datetime-like string variable as column value in Matillion

I am trying to set a string variable with the following format "YYYY-MM-DD HH:MM:SS" as a column value in Matillion with an SQL script component. My initial code was this: UPDATE "DB_MX_DEV"."STAGING".${target_table} SET insertion_date = '2022-09-24…
brenda
  • 656
  • 8
  • 24
0
votes
1 answer

Select columns mid Matillion transformation job

I'm a new Matillion user so suspect I'm overlooking an obvious answer... I am currently reading a number of identically formatted tables (yearly sales data) and vertically stacking them using a Unite component. As I am exploring the data rather…
Dave-C
  • 5
  • 2
  • 6
0
votes
1 answer

AWS SQS queue not triggering Matillion job

I have an SQS queue that receives a message with the file name that has been created in a target bucket. The process to send the message is: csv file is inserted into target_bucket. A message is sent to an SNS topic. The SNS topic triggers a lambda…
brenda
  • 656
  • 8
  • 24
0
votes
1 answer

Can Matillion ETL convert multiple CSV files to Parquet?

I have the following folder hierarchy in an S3 bucket: January/10 16b516c0-8f2a-eabd-770a-b8bbc83c5859.csv, 16b516c0-8f2a-eabd-770a-b8bbc83c5859.csv, … In other words, every folder represents a calendar day. I would like Matillion ETL to do the…
Victor Sotnikov
  • 177
  • 1
  • 2
  • 15
0
votes
0 answers

In Matillion query,I am able to create a query profile correctly but have errors with the parameters. "The value of error could not be accessed"

I am trying to extract data from Gainsight to Snowflake using Matillion using API. I was able to create the query profile where the data is pulled correctly, but with errors in the parameters. The error is "Exception Testing table - The error was…
Ambar Chandra
  • 1
0
votes
0 answers

Matillion Error - Authorization failed with redirect url of

I am getting following error while clicking on authentication link in matilion while managing OAuth. Authorization failed with redirect url of:…
Shivani Jadhav
  • 1
0
votes
1 answer

Repeat the previous Value for a null value in Snowflake

I'm loading merge excel cells using Matilion into Snowflake table. After loading into SF table, I'm trying to replace all nulls with the first column value. Below is the input data I/p: Expected O/P: I'm trying with the below sql but getting error…
sagyy_sf
  • 45
  • 5
0
votes
0 answers

How to create a pipeline in Matillion Data Loader from Facebook Content Insights?

I am unable to create a pipeline to get data from Facebook Content Insights to Snowflake. I have generated the page access token from Facebook graph explorer & added that as a parameter- "OAuthAccessToken". Error- #434 [Query Facebook] - Parameter…
Vanessa D'souza
  • 1
0
votes
1 answer

Load data from public Azure blob in Matillion

I am going through Matillion Academy (Building a Data Warehouse). There is a slide deck to follow online and I am running my own instance of Matillion to recreate the building of the warehouse. My Matillion is on Azure, as is my Snowflake…
Dieter VH
  • 3
  • 3
0
votes
1 answer

I am trying to delete a user from matillon which I have created by mistake using CURL command

So currently there are 2 user with similar id (one without space, other with space) in their ID. So I want to delete the user(other with space) but when I run the Delete Curl command it's not recognizing the userid (with space) in the curl…
tannu kumari
  • 1
0
votes
1 answer

Matillion Bash Script - How to Set an Environment Variable Value?

If I create an environment variable in a Matillion called "var_foo" (with a Type of "Text", a Behaviour of "Shared" and a default of "notset") I'm able to set and get the value of this variable in a Python script but not a Bash script. In Bash I…
FreeZey
  • 2,382
  • 3
  • 11
  • 23
0
votes
2 answers

Unable to connect two components in Matillion

enter image description hereI have two components on a canvas in Matillion. The instructions are to "use my mouse to connect the two components". I am unable to connect them. I can drag them, but no connection is created.
HilaryKoerner
  • 1
  • 2
0
votes
1 answer

S3 Staging option not available in Matillion Instance

I am going through Matillion Academy (Building a Data Warehouse). There is a slide deck to follow online and I am running my own instance of Matillion to recreate the building of the warehouse. I have entered all of the properties per the online…
HilaryKoerner
  • 1
  • 2
0
votes
1 answer

How to store Matillion job variable value in Snowflake table

I have an Orchestration job running in which I am using an iterator component. I have created a job variable which is reading filename for the iterator. Is their any way to store the variable value (i.e. filename) in a Snowflake table? Thank…
shiv.r
  • 1
  • 1
1 2
3
4 5 6