python sql_metadata to extract table names from SQL query

$30-250 AUD

Finalizat

Data postării:

circa 1 an în urmă

$30-250 AUD

Plata la predare

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

ID-ul proiectului: 36110203

Despre proiect

8 propuneri

Proiect la distanță

Activ: 1 an în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@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 în 1 zi

5,0

(2 recenzii)

2,9

8 freelanceri plasează o ofertă medie de $170 AUD pentru proiect

@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 în 1 zi

4,9

(88 recenzii)

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 în 5 zile

5,0

(2 recenzii)

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 în 1 zi

5,0

(1 recenzie)

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 în 2 zile

0,0

(0 recenzii)

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 în 7 zile