Lab Sql

I need to get a comma separated list of ids as a field for a messy third party api :s This is a sim… Read more Concat Group By In Vertica Sql

I'm trying to connect to a Vertica database using SQLAlchemy. I came across and installed a Ver… Read more Connecting To Vertica Database Using Sqlalchemy

I'm going to need to import 30k rows of data from a CSV file into a Vertica database. The code … Read more Import Data To Sql Using Python

I'm seeing unexpected behavior in Vertica's FIRST_VALUE() analytic function with the IGNORE… Read more Unexpected Behavior In First_value() With Ignore Nulls (vertica)

I am trying to upload pandas dataframe into Vertica Database was able to setup the engine and query… Read more Unable To Write Data To Vertica Database Using Python Sqlalchemy - Type "text" Does Not Exist

I want to query the first occurrence of every name according to the earliest date. The output shoul… Read more Find The First Key By Date Field Using Sql And Output Also Have Other Fields