Closed

Create a Snowflake query to get data

Hello I would like some one to create a snowflake query to get the data in the format as shown in tab 3 in the attached document. The table is present in tab 1 and the requirements are detailed in tab 2 .

Skills: SQL, MySQL

About the Client:
( 74 reviews ) NEWARK, United States

Project ID: #34340128

24 freelancers are bidding on average $38 for this job

NabeelAbid22

Hi, I will write query as per excel file requirements. I will start now. Ping me back, so we can discuss it further and start asap. Regards, Nabeel Abid

$30 USD in 1 day
(56 Reviews)
5.5
teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping u More

$20 USD in 1 day
(21 Reviews)
4.4
jpdestudio

Hi! I've seen your post and I am ready to take up the task. I can fix it asap. Please contact me if you are interested in me. Best regards. Juan.

$20 USD in 1 day
(7 Reviews)
4.8
dohungnd94

Hi bro. I loaded your csv in my snowflake account and successfully created a view that you need. Please hire me, I will send you the view right away. I have been a data engineer for more than 5 years and I have 1 year More

$40 USD in 1 day
(17 Reviews)
4.5
arunkumarragee

♦ PL/SQL Expert ♦ Database Developer ♦ Immediate Start ♦ I’m a Software Engineer with 9+ years of experience in DB development. I’m expertise in multiple databases Snowflake, MYSQL, Oracle, MSSQL and PostgreSQL. I woul More

$30 USD in 1 day
(2 Reviews)
3.2
noureen23

Hi There, I have gone through your requirement to get data in the shown format ,including project id from projects field. ************* Its Done ************* Kindly ping ,so i share the solution. Thanks for your ti More

$20 USD in 1 day
(8 Reviews)
3.0
dealmichael02

Dear Client. How are you doing? Thank you for posting this project, and I'm very happy to bid on your project. I've read carefully your project details. I have rich experiences related to your project. Your satisf More

$20 USD in 7 days
(0 Reviews)
0.0
anilk8523

I believe I have just the toolset you need to make this project a reality. Given my SQL experience for 5 year ago and good knowledge for coding , I’m confident I can deliver Fast and Resolve query with SQL .

$20 USD in 7 days
(0 Reviews)
0.0
mdrobiulhasan553

Hi there, I can help you to create a snowflake query to get the data in the format as shown in tab 3 . I am waiting your response to start work immediately.

$20 USD in 1 day
(0 Reviews)
0.0
jayacn

Hi, Hope this finds you well. I have good hands on experience in writing SQLs with Snowflake and can help accomplish the task. This makes me best match for this task.. Please consider my application and we can close i More

$20 USD in 3 days
(0 Reviews)
0.0
spartanavi

Hi there, I have completed this task. PFB the queries: Step 1: Create a sample table: JSON_TESTCASE. Keep the field PROJECTS data type as VARIANT and rest others can be VARCHAR. Step 2: Insert all the data into this t More

$30 USD in 1 day
(0 Reviews)
0.0
marcprotz

HI there! Thanks fro your job posting. I’ve carefully checked your requirements and really interested in this job. As a senior developer, i have rich experience and master skills of the MongoDB, NoSQL Couch & Mongo and More

$30 USD in 1 day
(0 Reviews)
0.0
Ritik55

Hello, I am ready to do this work for you can you talk about the work personally so that I can start the process.

$20 USD in 1 day
(0 Reviews)
0.0
eigensvw

Dear Client, I fully understand your requirements and can complete this project in time to your satisfaction. I have checked your data file and it shows that each Issue_id has up-to 52 project_ids. This is a quite big More

$400 USD in 3 days
(0 Reviews)
0.0
JenbagaramanJ

Actually i have done your project. I have created an SQL query to retrieve the data based on your requirement. You can contact me if you want to get it. Thank you.

$15 USD in 1 day
(0 Reviews)
0.0
ChaiEndDesigns

Don't be fooled by no reviews. We JUST got on this platform to deliver our services, thankfully we did. What makes us stand out from the competition is that we have a TEAM of Marketers with a COMBINED 30 YEARS OF exper More

$18 USD in 7 days
(0 Reviews)
0.0
ZL0025

I am currently engaged in Java software development related work in IT company. The main technologies used are spring boot, Java, jQuery, mysql, Oracle, redis, etc

$20 USD in 7 days
(0 Reviews)
0.0
nebojsaivic22

⭐⭐⭐⭐⭐5-Stars Rating for all of my Projects⭐⭐⭐⭐⭐ Hi Dear, I hope you are doing well and safe from COVID-19. I am a ?Professional Full Stack Web Developer? with 6 years of experience. Therefore, I think that I can impl More

$20 USD in 7 days
(0 Reviews)
0.0
(0 Reviews)
0.7
am28912

Hi there!, With more than 2years of experience in data engineering, Advanced SQL(My SQL) and data manipulation, I have the skills and the experience to meet your expectations, Also I have worked on many projects like t More

$20 USD in 1 day
(0 Reviews)
0.0