python sql_metadata to extract table names from SQL query

$30-250 AUD

Completed

Posted

about 1 year ago

$30-250 AUD

Paid on delivery

I have an existing python dataframe which contains the following columns. [login to view URL] [login to view URL] [login to view URL] I've already extracted data from the SQL Server processsnapshot table into a python dataframe. This works & is not part of the task. I would like to extract the table names from the existing dataframe (data) using Column [login to view URL] There are multiple rows of data. Using code from [login to view URL] I've been able to manually copy & paste the data, it works, but I'm after some automation. I would like to automate this process (there are hundreds of rows) The above code puts the results into a string I would like the recorded into a new dataframe & recorded with user & QueryStartTme. 1 result = 1 row. . ie. USER1 1/1/23 9:00:00:00 [login to view URL] USER1 1/1/23 9:00:00:00 [login to view URL] User 1 ran a query starting 1/1/23 9:00:00:00, their single query references 2 tables, so there are 2 seperate entries This task should factor in all table naming conventions. As programs like Tableau, Python, Alteryx, SQL users are running queries on server. In summary, I would like to extract all the table names from a query & have the results neatly presented in a new table.

Python

SQL

Software Architecture

Database Programming

Project ID: 36110203

About the project

8 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

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

Awarded to:

@vasylbetsadev

★★★★★♛ PYTHON EXPERT ♛★★★★★ Hello. I am happy to have the opportunity to help you. I have a deep understanding and experience in the areas of python that you mentioned. I can provide you perfect result within today. Let's discuss details over live chat. Thanks & Regards.

$140 AUD in 1 day

5.0

(2 reviews)

2.9

8 freelancers are bidding on average $170 AUD for this job

@mirzaahamza

Hey I am expert on python and I can help you with your project message me to discuss so that we can start working on it

$140 AUD in 1 day

4.9

(88 reviews)

5.7

@johnmichael2033

Hello? How are you today? I am Michael . I have thoroughly read the summary of your intriguing project. With my wide range of skills, I can complete it with ease. I've successfully finished tasks like this in the past. I'd be happy to talk to you about the project. Send me a message: I'd be happy to share my solution(s) with you. Thanks

$249.99 AUD in 5 days

5.0

(2 reviews)

4.1

@mupasa555simba

Hi, after reading over your post, I have come to know you want to extract table names from a query. I am a senior and dedicated web developer/architect who is proficient in python. As I started to work for Python from 2015, I am very familiar with python dataframe. I think it is perfect fit for my skill sets. Thanks in advance and please send me message for further discussion. Regards.

$100 AUD in 1 day

5.0

(1 review)

2.3

@Akihiro8314

Hello, Sir. I have read your description. I think I am the one you are looking for. I have mastered Python through 5+ years of experience. I can finish your task just in time with my SQL+Python and automation skills. I have also done many projects and always satisfied my clients. If you agree, please contact me soon. Best regards.

$200 AUD in 2 days

0.0

(0 reviews)

0.0

@Yngwigvs

Hello. How are you doing? I would like to propose for your project as I have a lot of experience with python and am very excited about SQL solutions integrated with python. I can write python code for you that will give you the output you want, whether it's just in a dataframe format in a variable or with a .csv or any other type of output. I can deliver it before 7 days if you want Just let me know if you are interested in my services.

$140 AUD in 7 days