Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, e.g. \+
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Answered
Does Anyone Know If You Can Export A Dataset (Ml) Directly From A Database To The Clearml-Data Or Have To Export Out As Csv First ?

Does anyone know if you can export a dataset (ML) directly from a database to the clearml-data Or have to export out as csv first ?

  
  
Posted 3 years ago
Votes Newest

Answers 4


DeliciousBluewhale87 you can try:
` import sqlite3
import pandas as pd

conn = sqlite3.connect('test_database')

sql_query = pd.read_sql_query ('''
SELECT
*
FROM products
''', conn)

sql_query.to_csv(...) `

  
  
Posted 3 years ago

No no, I mean now i can export a csv file into clearml-data. I was wondering if it possible to export directly from a sql database.

  
  
Posted 3 years ago

DeliciousBluewhale87 , Hi 🙂

You mean you created a dataset task on a certain server and you want to move that dataset task to another server?

  
  
Posted 3 years ago

I'm not aware of an ability to inject directly from an sql database. You can automate it by dumping from sql to csv, I assume

  
  
Posted 3 years ago
1K Views
4 Answers
3 years ago
one year ago
Tags