Find Jobs
Hire Freelancers

Create a Snowflake query to get data

$10-30 USD

Closed
Posted over 1 year ago

$10-30 USD

Paid on delivery
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 .
Project ID: 34340128

About the project

23 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average $39 USD for this job
User Avatar
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
5.0 (58 reviews)
5.7
5.7
User Avatar
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 using python, -Database development in (Mysql,Postgres,SQlite and SQl) -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel and Tableau -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa
$20 USD in 1 day
4.9 (21 reviews)
4.4
4.4
User Avatar
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
4.5 (8 reviews)
4.8
4.8
User Avatar
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 experience working with snowflake. Please don't hesitate to contact me at any time. Have a great day, thank you
$40 USD in 1 day
4.9 (18 reviews)
4.5
4.5
User Avatar
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 time and have a good day. Regards
$20 USD in 1 day
5.0 (8 reviews)
3.2
3.2
User Avatar
♦ 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 would be the right person for this task because I have hands-on and real-time experience in Snowflake database. I understood your requirement. Kindly feel free to get in touch to discuss further details. Thank you.
$30 USD in 1 day
5.0 (2 reviews)
3.2
3.2
User Avatar
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 satisfaction with the project is my top priority! If you give me a chance to work with you, then I will do my best to reach your requirements. I'm waiting for your kind response. Please send msg over chat. Let's go. I will do my best for you. Best Regards.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 it quickly. Best Jaya
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 table. Step 3: You can create a view using the below query: CREATE OR REPLACE VIEW JSON_TESTCASE_VW AS SELECT ISSUE_ID, CONTROL_ID, CONTROL_NAME, ISSUE_STATUS, ISSUE_SEVERITY, REPLACE(PARSE_JSON(PARSE_JSON(PROJECTS)[INDEX]):id,'"','') AS PROJECT_ID FROM ( SELECT * FROM JSON_TESTCASE, table(flatten(input => parse_json(PROJECTS))) ); P.S: If you don't want to see any duplicates, you can use DISTINCT while creating the VIEW
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 Node.js. Please contact me to discuss more. I can complete your project within your deadline and budget. I am an innovative and strategic thinking professional with a proven track record of consistently going above and beyond in meeting customer needs and providing more value to the product than what the customer is paying for. For this very reason, they always get back to us again and again with promising ideas and projects. Thanks.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 project to accomplish accurately and in time.
$400 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 experience that will deliver you quality results. Let’s get started!
$18 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 this before querying using snowflake and bigquery, Contact me to discuss more details.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have overall experience of 6 years and last 3 years have been working on Snowflake and have been part of large scale migration projects and also implemented json parsing solutions in the past. Also i am a snowflake certified professional
$25 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a graduate of the university of Colorado System with Data Analysis and IT specialization and more than a year of experience using SQL and programming languages for data analysis and visualization. I am familiar with snowflake and I am very good at time management and delivering projects within the required time frame and assigned budget.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
NEWARK, United States
5.0
77
Payment method verified
Member since Mar 3, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.