python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - matillion

Using SQL and Matillion for Employee table, I need to pull only the most recent employee hire date

This is the code I wrote in SSMS which works fine for my purposes however trying to use the same principles with Matillion (yes I have to use Matillion at my company) I am still getting duplicate empl...
test-img

Anomaly

sql

sql-server

matillion

Votes: 0

Answers: 1

Latest Answer

This will produce a query that gives equivalent results to what you're doing above: For the subquery: Table Input from [SuccessFactorsCensus].[dbo].[Census] Aggregate component - add Grouping on Pers...
test-img

Nathan Griffiths

Need to send email with Attachment from Matillion Tool

Need to send email with Attachment from Matillion Tool I have checked SNS Message,Send Email component from Matillion but it does not have attachment option. I have Error log table into Amazon Redshif...
test-img

Satis Chaudhar

email-attachments

matillion

Votes: 0

Answers: 2

Latest Answer

Based on this message on the Matillion site, it looks like currently there is no built-in component for sending an email with an attachment, but it is on the product roadmap to add one. There are some...
test-img

53epo

ModuleNotFoundError: No module named 'boto3' - Matillion

I've installed python3 and boto3, and i want to run my python script from Matillion but it complains about boto3 module not being available: Traceback (most recent call last): File "/tmp/interp...
test-img

alterego

python

boto3

matillion

Votes: 0

Answers: 1

Latest Answer

As @Tzane commented, issue was related to paths. The path where i had boto3 installed (/usr/local/lib/python3.6/site-packages/boto3) was not in python paths. So, first uninstall boto3: pip uninstall b...
test-img

alterego

Matillion: Delete files from Azure Blob Storage Container and Windows Fileshare

I have a use case where I am Transferring XML files from Windows fileshare to Azure Blob Storage and then loading data to Snowflake Tables. I am using Matillion to achieve this. The Windows Fileshare ...
test-img

shiv.r

azure

fileshare

matillion

Votes: 0

Answers: 1

Latest Answer

you can delete the files from blob storage using the matillion python script component (orchestration->scripting->Python script) here is an example of python code to delete blob items and contai...
test-img

peterb

Posts

Questions

Blogs

Jobs