Did you already create the 'FactCrypto' table in MSSQL before connecting or you just gave a table name. I am trying to write to SQL but I always get error.
Did you find a way? Im kinda of a noob and i need my code to run daily without fail in order for it to retrieve data from rest api’s and load it to our local database. I tried uploading my code to an app function in azure but since it has a dynamic ip address I haven’t been able to make it work (permission errors). Theres always task scheduler on a local computer but i can’t always trust it’ll be on. Any ideas?
Hi, I have a key for api (trial version) of printfriendly website.. is this video meant for the purpose of "How to extract that api & use it forever for free" ?
In that suppose same data came again how it will load for example yesterday one row it's ram next day also we get same data how to it will load this Data this means duplicate data.
thanks for that! we need more of these please. ETL and ELT processes.
@@MICHAIL_NIKOLIOUDAKIS sure Michail!
Superb, thanks!
Thank you, i did as it is;Now it worked for me
@@FaisalMasood-q6g glad it helped you!
Super helpful video. Thanks mahn🤗
Thanks Prince, Glad you liked it ☺
Very helpful! Thank you.
Thanks Nikhil!
Thank you, you made the process very easy!
Glad it helped
Excellent man
Thanks Madhusudan!
Very helpful 👍
Thanks Charan !
very useful :) thank you
Thanks Narasimha
Thank you.
Did you already create the 'FactCrypto' table in MSSQL before connecting or you just gave a table name.
I am trying to write to SQL but I always get error.
Just gave a table name
How we can automate the process of data fetching from a live data API and data dumping without running the code again and again?
Hi Aakash, use any job scheduler like Apache airflow, SQL server agent,...
Did you find a way? Im kinda of a noob and i need my code to run daily without fail in order for it to retrieve data from rest api’s and load it to our local database. I tried uploading my code to an app function in azure but since it has a dynamic ip address I haven’t been able to make it work (permission errors). Theres always task scheduler on a local computer but i can’t always trust it’ll be on. Any ideas?
Hi, Do i need to create a DB structure in MSSQL first and then write code to fetch data? Or will it create the table automatic??
Hi Tejaswi, just create database , table will be created automatically with the name you provide
Can you make a video how to push the data from snowflake table to api endpoint
Hi, I have a key for api (trial version) of printfriendly website.. is this video meant for the purpose of "How to extract that api & use it forever for free" ?
Hi, yes boss
In which tool you are creating this phython code?
PyCharm
For all 3 imports, can you please help with the error :: Import 'requests' could not be resolved by Pylance???
How can we automate data backup and download data from salesforce automatically in the local storage
how can we write the header if we want to fetch pools table from uniswap api
Can you please provide website or resource where can we find such free APIs
I am trying to connect to Sql workbench but always get error, I dont know exact code for engine. Any help is appreciated.
In that suppose same data came again how it will load for example yesterday one row it's ram next day also we get same data how to it will load this Data this means duplicate data.
Hi Samhudaya, In 'if_exists' parameter use 'append' as value so that it'll load only new rows to the table.
Can you please share API link
api.coincap.io/v2/assets
sql not connect
SQL Server is connected
@@thebihub engine.connect show error
In every video there is a different way of fetching data
Its very confusing, which to remember
Hi Suman , may I know which part is confused for you so that I can clear it