redivis.query

redivis.query(query_string) → Query

Execute a SQL query across any tables on Redivis.

Parameters:

query_string : str The SQL query to execute. Must follow the Redivis SQL query syntax.

Returns:

Query

Examples

# The query can reference any table on Redivis 
query = redivis.query("""
    SELECT * 
    FROM demo.iris_species.iris 
    WHERE SepalLengthCm > 5
""")
query.to_pandas_dataframe()
# 	Id	SepalLengthCm	SepalWidthCm	PetalLengthCm	PetalWidthCm	Species
# 0	33	5.2	        4.1	        1.5	        0.1	        Iris-setosa
# ...