python sql_metadata to extract table names from SQL query

$30-250 AUD

Terminado

Publicado

hace casi 2 años

$30-250 AUD

Pagado a la entrega

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 del proyecto: 36110203

Información sobre el proyecto

7 propuestas

Proyecto remoto

Activo hace 2 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 1 día

5,0

(2 comentarios)

2,9

7 freelancers están ofertando un promedio de $174 AUD por este trabajo

@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 en 5 días

5,0

(2 comentarios)

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 en 1 día

5,0

(1 comentario)

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 en 2 días

0,0

(0 comentarios)

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 en 7 días