I am new to MemSQL . i have just created an account in MemSql and able to access only
MemSQL studio. I want to create a simple Pipeline in MemSQL to ingest data into MemSQL database . i have created user admin .
Question : Where do i need to write ‘create pipeline syntax’ in MemSQL , can i write in MemSQL studio-> SQL editor - Assuming i want to load a simple csv / json file from AWS s3 ( i already uploaded json file in aws s3 bucket)
Please suggest , where i can create a pipeline in MemSQL and how to i provide privileges to my admin user in singlestore studio.
Note : Apart from MemSQL studio , i wonot any MemSQL tool or any external database to access. and i am not permitted to installed any MemSQL tool on my machine . I can only access MemSQL studio.
I do have access to aws s3 env .
If anyone can guide me.