Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

MongoDB to Redshift

Hi,

Using MongoDB query component to load data Redshift....

First i was try basic option gave all credentials perfect but it did't shows all database names...

And changed to advanced using sql query...possibilities to directly using sql queries to load redshift table????

I was tried sql query but loaded all fields are null vallues....


Thanks
Ganesh

8 Community Answers

Ganesh Pitchai —

Sorry, i gave database name it did't shows the datasource names!!!!!


Thanks


Matillion Agent  

Ian Funnell —

Hi Ganesh,

You’re right, there is no dropdown list for the “Database” property of the MongoDB Query. Instead you have to simply type the name.

In Advanced Mode you can type your own SQL query. For example this works on Matillion’s own internal database:

SELECT id, name
FROM projects

Best regards,
Ian


Ganesh Pitchai —

Hi,

Sorry gave database name gave..but Datasource did't display in dropdown in my case...

Thanks
Ganesh


Matillion Agent  

Ian Funnell —

Hi Ganesh,

Yes, in basic mode the dropdown should show all the available Data Sources.

When configuring the MongoDB Query component, set the properties starting at the top of the list and working downwards. For example:

  • Basic/Advanced Mode = Basic
  • Server = the IP address of your MongoDB server
  • Database = the name of the database you’re trying to access

If the Server or Database are not correct, or if there is a network problem preventing Matillion from accessing the MongoDB database, the Status will confusingly still show as “OK” for those properties. Only when you open the Data Source property you’ll find the dropdown list is empty.

Are you certain that the Server and Database names are correct, and that Matillion has network access to the MongoDB server on port 27017?

Best regards,
Ian


Ganesh Pitchai —

Hi Lan,

I have a data
[{field1:001},
{field:002}]
array of how can i select particular fields??? to load to redshift

Basic/Advanced Mode = Basic mode

Thanks
Ganesh


Matillion Agent  

Kalyan Arangam —

Hi Ganesh,

I would expect basic mode to show you two column names – field1 and field.

In advanced mode, you may write the following query -

select field1, field from tablename

You have not mentioned if you see any errors. In basic mode, we tend to display an error if we are unable to display any column names. Do you see any errors in basic mode?

In Basic mode, Does the Data Source field give you a list of tables?

Best
Kalyan


Ganesh Pitchai —

Hi kalyan,

i didnt have any errors but i have a list of fields name...i had a data in nested arrays...dont know how to select particular data in nested array!!!!

how to give in Dataselection tab in the nested data????

Thanks
Ganesh


Ganesh Pitchai —

Hi,

I have resolved the problem using flatten arrays option... Now easy to access every fields...


Thanks
Ganesh

Post Your Community Answer

To add an answer please login